{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "%matplotlib inline"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "from IPython.core.interactiveshell import InteractiveShell\n",
    "InteractiveShell.ast_node_interactivity = \"all\""
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "maotai_tmall = pd.read_csv(r'data/maotai_tmall.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>时间</th>\n",
       "      <th>商品名</th>\n",
       "      <th>价格</th>\n",
       "      <th>销量</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2017-8-11</td>\n",
       "      <td>【酒厂自营】茅台王子酒 46度 500ml贵州茅台王子酱香型白酒</td>\n",
       "      <td>169.0</td>\n",
       "      <td>799</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2017-8-11</td>\n",
       "      <td>悠蜜蓝莓利口酒三瓶（8度）+蓝莓干两袋（4色随机）组合</td>\n",
       "      <td>258.0</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2017-8-11</td>\n",
       "      <td>【酒厂自营】茅台汉酱酒 51度 375ml贵州茅台 汉酱酒酱香白酒</td>\n",
       "      <td>368.0</td>\n",
       "      <td>47</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2017-8-11</td>\n",
       "      <td>【酒厂自营】茅台干红葡萄酒特选级750ml</td>\n",
       "      <td>179.0</td>\n",
       "      <td>69</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2017-8-11</td>\n",
       "      <td>赖茅酒（端曲）53度500ml</td>\n",
       "      <td>199.0</td>\n",
       "      <td>186</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>2017-8-11</td>\n",
       "      <td>【酒厂自营】茅台干红葡萄酒（红色喜庆）11%vol750ml</td>\n",
       "      <td>49.0</td>\n",
       "      <td>218</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>2017-8-11</td>\n",
       "      <td>【酒厂自营】茅台干红葡萄酒（蓝色喜庆）11%vol750ml</td>\n",
       "      <td>49.0</td>\n",
       "      <td>286</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>2017-8-11</td>\n",
       "      <td>【酒厂自营】750m珍藏级 干红葡萄酒（单支）</td>\n",
       "      <td>229.0</td>\n",
       "      <td>251</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>2017-8-11</td>\n",
       "      <td>【酒厂自营】汉酱酒51度125ml*4瓶装贵州茅台股份酱香型礼盒</td>\n",
       "      <td>468.0</td>\n",
       "      <td>182</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>2017-8-11</td>\n",
       "      <td>【酒厂自营】凤祥迎宾53度500ml</td>\n",
       "      <td>139.0</td>\n",
       "      <td>562</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>2017-8-11</td>\n",
       "      <td>【酒厂自营】茅台醇52度500ml贵州茅台技开地之醇浓香型白酒</td>\n",
       "      <td>289.0</td>\n",
       "      <td>82</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>2017-8-11</td>\n",
       "      <td>【酒厂自营】2013款茅台迎宾酒53度500ml</td>\n",
       "      <td>119.0</td>\n",
       "      <td>4356</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>2017-8-11</td>\n",
       "      <td>【酒厂自营】茅台王子酒53度 500ml酱门经典茅台股份酱香白酒</td>\n",
       "      <td>289.0</td>\n",
       "      <td>1645</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>2017-8-11</td>\n",
       "      <td>【酒厂自营】53度茅台王子酒500ml</td>\n",
       "      <td>189.0</td>\n",
       "      <td>3752</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>2017-8-11</td>\n",
       "      <td>【酒厂自营】 悠蜜umeet蓝莓利口酒 茅台伴侣绿野仙子</td>\n",
       "      <td>78.0</td>\n",
       "      <td>335</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>2017-8-11</td>\n",
       "      <td>酒厂自营 悠蜜umeet蓝莓利口酒 茅台伴侣红唇佳人 12度</td>\n",
       "      <td>78.0</td>\n",
       "      <td>636</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>2017-8-11</td>\n",
       "      <td>【酒厂自营】 悠蜜umeet蓝莓利口酒 8度三瓶组合</td>\n",
       "      <td>208.0</td>\n",
       "      <td>132</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>2017-8-11</td>\n",
       "      <td>【酒厂自营】贵州大曲（80年代电商专享）</td>\n",
       "      <td>299.0</td>\n",
       "      <td>1002</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>2017-8-11</td>\n",
       "      <td>酒厂自营 悠蜜umeet蓝莓利口酒 茅台伴侣紫魅公主 12度</td>\n",
       "      <td>78.0</td>\n",
       "      <td>395</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>2017-8-11</td>\n",
       "      <td>【酒厂自营】茅台醇52度500ml贵州茅台技开天之醇浓香型白酒</td>\n",
       "      <td>399.0</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>2017-8-11</td>\n",
       "      <td>【酒厂自营】茅台干红葡萄酒国韵11%vol750ml</td>\n",
       "      <td>39.0</td>\n",
       "      <td>1332</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>2017-8-11</td>\n",
       "      <td>【酒厂自营】茅台醇52度 500ml贵州茅台技开人之醇浓香型白酒</td>\n",
       "      <td>229.0</td>\n",
       "      <td>50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>2017-8-11</td>\n",
       "      <td>【酒厂自营】茅台迎宾酒43度500ml</td>\n",
       "      <td>99.0</td>\n",
       "      <td>4533</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>2017-8-11</td>\n",
       "      <td>酒厂自营 悠蜜umeet蓝莓利口酒 茅台伴侣6色组合装</td>\n",
       "      <td>408.0</td>\n",
       "      <td>9139</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>2017-8-11</td>\n",
       "      <td>悠蜜蓝莓利口酒三瓶（12度）+蓝莓干两袋（4色随机）组合</td>\n",
       "      <td>258.0</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>2017-8-11</td>\n",
       "      <td>【酒厂自营】茅台醇福醇53度500ml</td>\n",
       "      <td>589.0</td>\n",
       "      <td>175</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>2017-8-11</td>\n",
       "      <td>【酒厂自营】 悠蜜umeet蓝莓利口酒 12度三瓶组合</td>\n",
       "      <td>208.0</td>\n",
       "      <td>116</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>2017-8-11</td>\n",
       "      <td>【酒厂自营】汉酱酒51度125ml贵州茅台股份酱香型汉酱白酒</td>\n",
       "      <td>129.0</td>\n",
       "      <td>259</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>2017-8-11</td>\n",
       "      <td>【酒厂自营】仁酒53度125ml贵州茅台仁酒茅台股份酱香型白酒</td>\n",
       "      <td>119.0</td>\n",
       "      <td>209</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>2017-8-11</td>\n",
       "      <td>【酒厂自营】茅台醇美醇53度500ml</td>\n",
       "      <td>389.0</td>\n",
       "      <td>172</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>108</th>\n",
       "      <td>2017-08-21</td>\n",
       "      <td>【酒厂自营】茅台干红葡萄酒（蓝色喜庆）11%vol750ml</td>\n",
       "      <td>49.0</td>\n",
       "      <td>318</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>109</th>\n",
       "      <td>2017-08-21</td>\n",
       "      <td>【酒厂自营】茅台醇52度500ml贵州茅台技开地之醇浓香型白酒</td>\n",
       "      <td>289.0</td>\n",
       "      <td>85</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>110</th>\n",
       "      <td>2017-08-21</td>\n",
       "      <td>【酒厂自营】汉酱酒51度125ml贵州茅台股份酱香型汉酱白酒</td>\n",
       "      <td>129.0</td>\n",
       "      <td>261</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>111</th>\n",
       "      <td>2017-08-21</td>\n",
       "      <td>【酒厂自营】 悠蜜umeet蓝莓利口酒 8度三瓶组合</td>\n",
       "      <td>208.0</td>\n",
       "      <td>139</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>112</th>\n",
       "      <td>2017-08-21</td>\n",
       "      <td>赖茅酒（传承）53度500ml</td>\n",
       "      <td>399.0</td>\n",
       "      <td>372</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>113</th>\n",
       "      <td>2017-08-21</td>\n",
       "      <td>【酒厂自营】茅台干红葡萄酒特选级750ml</td>\n",
       "      <td>179.0</td>\n",
       "      <td>71</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>114</th>\n",
       "      <td>2017-08-21</td>\n",
       "      <td>【酒厂自营】凤祥迎宾53度500ml</td>\n",
       "      <td>139.0</td>\n",
       "      <td>595</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>115</th>\n",
       "      <td>2017-08-21</td>\n",
       "      <td>【酒厂自营】仁酒53度125ml贵州茅台仁酒茅台股份酱香型白酒</td>\n",
       "      <td>119.0</td>\n",
       "      <td>213</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>116</th>\n",
       "      <td>2017-08-21</td>\n",
       "      <td>【酒厂自营】750ml莎当妮干白葡萄酒（单支）</td>\n",
       "      <td>139.0</td>\n",
       "      <td>325</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>117</th>\n",
       "      <td>2017-08-21</td>\n",
       "      <td>【酒厂自营】 悠蜜umeet蓝莓利口酒 12度三瓶组合</td>\n",
       "      <td>208.0</td>\n",
       "      <td>120</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>118</th>\n",
       "      <td>2017-08-21</td>\n",
       "      <td>酒厂自营 悠蜜umeet蓝莓利口酒 茅台伴侣紫魅公主 12度</td>\n",
       "      <td>78.0</td>\n",
       "      <td>399</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>119</th>\n",
       "      <td>2017-08-21</td>\n",
       "      <td>【酒厂自营】贵州大曲（80年代电商专享）</td>\n",
       "      <td>299.0</td>\n",
       "      <td>1023</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>120</th>\n",
       "      <td>2017-08-21</td>\n",
       "      <td>赖茅酒（端曲）53度500ml</td>\n",
       "      <td>199.0</td>\n",
       "      <td>201</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>121</th>\n",
       "      <td>2017-08-21</td>\n",
       "      <td>【酒厂自营】750m珍藏级 干红葡萄酒（单支）</td>\n",
       "      <td>229.0</td>\n",
       "      <td>254</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>122</th>\n",
       "      <td>2017-08-21</td>\n",
       "      <td>【酒厂自营】茅台醇52度 500ml贵州茅台技开人之醇浓香型白酒</td>\n",
       "      <td>229.0</td>\n",
       "      <td>50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>123</th>\n",
       "      <td>2017-08-21</td>\n",
       "      <td>【酒厂自营】 悠蜜umeet蓝莓利口酒 茅台伴侣空灵女侠</td>\n",
       "      <td>78.0</td>\n",
       "      <td>949</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>124</th>\n",
       "      <td>2017-08-21</td>\n",
       "      <td>【酒厂自营】茅台迎宾酒（花开富贵）53度500ml</td>\n",
       "      <td>159.0</td>\n",
       "      <td>380</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>125</th>\n",
       "      <td>2017-08-21</td>\n",
       "      <td>【酒厂自营】茅台醇顺醇53度500ml茅台技开白酒</td>\n",
       "      <td>239.0</td>\n",
       "      <td>174</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>126</th>\n",
       "      <td>2017-08-21</td>\n",
       "      <td>【酒厂自营】2013款茅台迎宾酒53度500ml</td>\n",
       "      <td>119.0</td>\n",
       "      <td>4412</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>127</th>\n",
       "      <td>2017-08-21</td>\n",
       "      <td>【酒厂自营】汉酱酒51度125ml*4瓶装贵州茅台股份酱香型礼盒</td>\n",
       "      <td>468.0</td>\n",
       "      <td>194</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>128</th>\n",
       "      <td>2017-08-21</td>\n",
       "      <td>【酒厂自营】黑方礼盒750ml茅台干红葡萄酒（单支）</td>\n",
       "      <td>409.0</td>\n",
       "      <td>188</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>129</th>\n",
       "      <td>2017-08-21</td>\n",
       "      <td>赖茅酒（重沙）53度500ml</td>\n",
       "      <td>299.0</td>\n",
       "      <td>308</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>130</th>\n",
       "      <td>2017-08-21</td>\n",
       "      <td>【酒厂自营】茅台干红葡萄酒国韵11%vol750ml</td>\n",
       "      <td>39.0</td>\n",
       "      <td>1400</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>131</th>\n",
       "      <td>2017-08-21</td>\n",
       "      <td>悠蜜蓝莓利口酒三瓶（8度）+蓝莓干两袋（4色随机）组合</td>\n",
       "      <td>258.0</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>132</th>\n",
       "      <td>2017-08-21</td>\n",
       "      <td>【酒厂自营】茅台干红葡萄酒（闻鸡起舞）13%vol750ml</td>\n",
       "      <td>128.0</td>\n",
       "      <td>128</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>133</th>\n",
       "      <td>2017-08-21</td>\n",
       "      <td>【酒厂自营】茅台醇美醇53度500ml</td>\n",
       "      <td>389.0</td>\n",
       "      <td>184</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>134</th>\n",
       "      <td>2017-08-21</td>\n",
       "      <td>【酒厂自营】茅台醇52度500ml贵州茅台技开天之醇浓香型白酒</td>\n",
       "      <td>399.0</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>135</th>\n",
       "      <td>2017-08-21</td>\n",
       "      <td>【酒厂自营】茅台原装葡萄酒 750ml葡萄酒  茅台干红葡萄酒</td>\n",
       "      <td>99.0</td>\n",
       "      <td>165</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>136</th>\n",
       "      <td>2017-08-21</td>\n",
       "      <td>【酒厂自营】 悠蜜umeet蓝莓利口酒 茅台伴侣烈焰女王</td>\n",
       "      <td>78.0</td>\n",
       "      <td>1095</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>137</th>\n",
       "      <td>2017-08-21</td>\n",
       "      <td>【酒厂自营】茅台王子酒 46度 500ml贵州茅台王子酱香型白酒</td>\n",
       "      <td>169.0</td>\n",
       "      <td>802</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>138 rows × 4 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "             时间                                商品名     价格    销量\n",
       "0     2017-8-11   【酒厂自营】茅台王子酒 46度 500ml贵州茅台王子酱香型白酒  169.0   799\n",
       "1     2017-8-11        悠蜜蓝莓利口酒三瓶（8度）+蓝莓干两袋（4色随机）组合  258.0     4\n",
       "2     2017-8-11  【酒厂自营】茅台汉酱酒 51度 375ml贵州茅台 汉酱酒酱香白酒  368.0    47\n",
       "3     2017-8-11              【酒厂自营】茅台干红葡萄酒特选级750ml  179.0    69\n",
       "4     2017-8-11                    赖茅酒（端曲）53度500ml  199.0   186\n",
       "5     2017-8-11     【酒厂自营】茅台干红葡萄酒（红色喜庆）11%vol750ml   49.0   218\n",
       "6     2017-8-11     【酒厂自营】茅台干红葡萄酒（蓝色喜庆）11%vol750ml   49.0   286\n",
       "7     2017-8-11            【酒厂自营】750m珍藏级 干红葡萄酒（单支）  229.0   251\n",
       "8     2017-8-11   【酒厂自营】汉酱酒51度125ml*4瓶装贵州茅台股份酱香型礼盒  468.0   182\n",
       "9     2017-8-11                 【酒厂自营】凤祥迎宾53度500ml  139.0   562\n",
       "10    2017-8-11    【酒厂自营】茅台醇52度500ml贵州茅台技开地之醇浓香型白酒  289.0    82\n",
       "11    2017-8-11           【酒厂自营】2013款茅台迎宾酒53度500ml  119.0  4356\n",
       "12    2017-8-11   【酒厂自营】茅台王子酒53度 500ml酱门经典茅台股份酱香白酒  289.0  1645\n",
       "13    2017-8-11                【酒厂自营】53度茅台王子酒500ml  189.0  3752\n",
       "14    2017-8-11       【酒厂自营】 悠蜜umeet蓝莓利口酒 茅台伴侣绿野仙子   78.0   335\n",
       "15    2017-8-11     酒厂自营 悠蜜umeet蓝莓利口酒 茅台伴侣红唇佳人 12度   78.0   636\n",
       "16    2017-8-11         【酒厂自营】 悠蜜umeet蓝莓利口酒 8度三瓶组合  208.0   132\n",
       "17    2017-8-11               【酒厂自营】贵州大曲（80年代电商专享）  299.0  1002\n",
       "18    2017-8-11     酒厂自营 悠蜜umeet蓝莓利口酒 茅台伴侣紫魅公主 12度   78.0   395\n",
       "19    2017-8-11    【酒厂自营】茅台醇52度500ml贵州茅台技开天之醇浓香型白酒  399.0    13\n",
       "20    2017-8-11         【酒厂自营】茅台干红葡萄酒国韵11%vol750ml   39.0  1332\n",
       "21    2017-8-11   【酒厂自营】茅台醇52度 500ml贵州茅台技开人之醇浓香型白酒  229.0    50\n",
       "22    2017-8-11                【酒厂自营】茅台迎宾酒43度500ml   99.0  4533\n",
       "23    2017-8-11        酒厂自营 悠蜜umeet蓝莓利口酒 茅台伴侣6色组合装  408.0  9139\n",
       "24    2017-8-11       悠蜜蓝莓利口酒三瓶（12度）+蓝莓干两袋（4色随机）组合  258.0     4\n",
       "25    2017-8-11                【酒厂自营】茅台醇福醇53度500ml  589.0   175\n",
       "26    2017-8-11        【酒厂自营】 悠蜜umeet蓝莓利口酒 12度三瓶组合  208.0   116\n",
       "27    2017-8-11     【酒厂自营】汉酱酒51度125ml贵州茅台股份酱香型汉酱白酒  129.0   259\n",
       "28    2017-8-11    【酒厂自营】仁酒53度125ml贵州茅台仁酒茅台股份酱香型白酒  119.0   209\n",
       "29    2017-8-11                【酒厂自营】茅台醇美醇53度500ml  389.0   172\n",
       "..          ...                                ...    ...   ...\n",
       "108  2017-08-21     【酒厂自营】茅台干红葡萄酒（蓝色喜庆）11%vol750ml   49.0   318\n",
       "109  2017-08-21    【酒厂自营】茅台醇52度500ml贵州茅台技开地之醇浓香型白酒  289.0    85\n",
       "110  2017-08-21     【酒厂自营】汉酱酒51度125ml贵州茅台股份酱香型汉酱白酒  129.0   261\n",
       "111  2017-08-21         【酒厂自营】 悠蜜umeet蓝莓利口酒 8度三瓶组合  208.0   139\n",
       "112  2017-08-21                    赖茅酒（传承）53度500ml  399.0   372\n",
       "113  2017-08-21              【酒厂自营】茅台干红葡萄酒特选级750ml  179.0    71\n",
       "114  2017-08-21                 【酒厂自营】凤祥迎宾53度500ml  139.0   595\n",
       "115  2017-08-21    【酒厂自营】仁酒53度125ml贵州茅台仁酒茅台股份酱香型白酒  119.0   213\n",
       "116  2017-08-21            【酒厂自营】750ml莎当妮干白葡萄酒（单支）  139.0   325\n",
       "117  2017-08-21        【酒厂自营】 悠蜜umeet蓝莓利口酒 12度三瓶组合  208.0   120\n",
       "118  2017-08-21     酒厂自营 悠蜜umeet蓝莓利口酒 茅台伴侣紫魅公主 12度   78.0   399\n",
       "119  2017-08-21               【酒厂自营】贵州大曲（80年代电商专享）  299.0  1023\n",
       "120  2017-08-21                    赖茅酒（端曲）53度500ml  199.0   201\n",
       "121  2017-08-21            【酒厂自营】750m珍藏级 干红葡萄酒（单支）  229.0   254\n",
       "122  2017-08-21   【酒厂自营】茅台醇52度 500ml贵州茅台技开人之醇浓香型白酒  229.0    50\n",
       "123  2017-08-21       【酒厂自营】 悠蜜umeet蓝莓利口酒 茅台伴侣空灵女侠   78.0   949\n",
       "124  2017-08-21          【酒厂自营】茅台迎宾酒（花开富贵）53度500ml  159.0   380\n",
       "125  2017-08-21          【酒厂自营】茅台醇顺醇53度500ml茅台技开白酒  239.0   174\n",
       "126  2017-08-21           【酒厂自营】2013款茅台迎宾酒53度500ml  119.0  4412\n",
       "127  2017-08-21   【酒厂自营】汉酱酒51度125ml*4瓶装贵州茅台股份酱香型礼盒  468.0   194\n",
       "128  2017-08-21         【酒厂自营】黑方礼盒750ml茅台干红葡萄酒（单支）  409.0   188\n",
       "129  2017-08-21                    赖茅酒（重沙）53度500ml  299.0   308\n",
       "130  2017-08-21         【酒厂自营】茅台干红葡萄酒国韵11%vol750ml   39.0  1400\n",
       "131  2017-08-21        悠蜜蓝莓利口酒三瓶（8度）+蓝莓干两袋（4色随机）组合  258.0     4\n",
       "132  2017-08-21     【酒厂自营】茅台干红葡萄酒（闻鸡起舞）13%vol750ml  128.0   128\n",
       "133  2017-08-21                【酒厂自营】茅台醇美醇53度500ml  389.0   184\n",
       "134  2017-08-21    【酒厂自营】茅台醇52度500ml贵州茅台技开天之醇浓香型白酒  399.0    13\n",
       "135  2017-08-21    【酒厂自营】茅台原装葡萄酒 750ml葡萄酒  茅台干红葡萄酒   99.0   165\n",
       "136  2017-08-21       【酒厂自营】 悠蜜umeet蓝莓利口酒 茅台伴侣烈焰女王   78.0  1095\n",
       "137  2017-08-21   【酒厂自营】茅台王子酒 46度 500ml贵州茅台王子酱香型白酒  169.0   802\n",
       "\n",
       "[138 rows x 4 columns]"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "maotai_tmall"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {
    "collapsed": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>价格</th>\n",
       "      <th>销量</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>count</th>\n",
       "      <td>138.000000</td>\n",
       "      <td>138.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>mean</th>\n",
       "      <td>217.688406</td>\n",
       "      <td>785.695652</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>std</th>\n",
       "      <td>131.109070</td>\n",
       "      <td>1601.808032</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>min</th>\n",
       "      <td>39.000000</td>\n",
       "      <td>4.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25%</th>\n",
       "      <td>99.000000</td>\n",
       "      <td>136.750000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50%</th>\n",
       "      <td>199.000000</td>\n",
       "      <td>254.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75%</th>\n",
       "      <td>299.000000</td>\n",
       "      <td>625.750000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>max</th>\n",
       "      <td>589.000000</td>\n",
       "      <td>9217.000000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "               价格           销量\n",
       "count  138.000000   138.000000\n",
       "mean   217.688406   785.695652\n",
       "std    131.109070  1601.808032\n",
       "min     39.000000     4.000000\n",
       "25%     99.000000   136.750000\n",
       "50%    199.000000   254.000000\n",
       "75%    299.000000   625.750000\n",
       "max    589.000000  9217.000000"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "maotai_tmall.describe()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "#茅台醇属于技术开发公司，悠蜜为生态农业公司，葡萄酒为葡萄酒公司\n",
    "maotai_labels = ['王子酒', '悠蜜', '汉酱酒', '葡萄酒', '迎宾', '赖茅', '茅台醇', '贵州大曲', '仁酒']\n",
    "maotai_label_list = []\n",
    "for i in maotai_tmall['商品名']:\n",
    "    for j in maotai_labels:\n",
    "        if j in i:\n",
    "            maotai_label_list.append(j)\n",
    "            break\n",
    "    else:\n",
    "        maotai_label_list.append('伊利')\n",
    "maotai_tmall['品牌'] = maotai_label_list"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "maotai_tmall['销售额'] = maotai_tmall['价格'] * maotai_tmall['销量']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "mtmall = maotai_tmall[(maotai_tmall['品牌'] != '悠蜜') & (maotai_tmall['品牌'] != '葡萄酒') & (maotai_tmall['品牌'] != '贵州醇')]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>时间</th>\n",
       "      <th>商品名</th>\n",
       "      <th>价格</th>\n",
       "      <th>销量</th>\n",
       "      <th>品牌</th>\n",
       "      <th>销售额</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2017-8-11</td>\n",
       "      <td>【酒厂自营】茅台王子酒 46度 500ml贵州茅台王子酱香型白酒</td>\n",
       "      <td>169.0</td>\n",
       "      <td>799</td>\n",
       "      <td>王子酒</td>\n",
       "      <td>135031.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2017-8-11</td>\n",
       "      <td>【酒厂自营】茅台汉酱酒 51度 375ml贵州茅台 汉酱酒酱香白酒</td>\n",
       "      <td>368.0</td>\n",
       "      <td>47</td>\n",
       "      <td>汉酱酒</td>\n",
       "      <td>17296.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2017-8-11</td>\n",
       "      <td>赖茅酒（端曲）53度500ml</td>\n",
       "      <td>199.0</td>\n",
       "      <td>186</td>\n",
       "      <td>赖茅</td>\n",
       "      <td>37014.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>2017-8-11</td>\n",
       "      <td>【酒厂自营】汉酱酒51度125ml*4瓶装贵州茅台股份酱香型礼盒</td>\n",
       "      <td>468.0</td>\n",
       "      <td>182</td>\n",
       "      <td>汉酱酒</td>\n",
       "      <td>85176.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>2017-8-11</td>\n",
       "      <td>【酒厂自营】凤祥迎宾53度500ml</td>\n",
       "      <td>139.0</td>\n",
       "      <td>562</td>\n",
       "      <td>迎宾</td>\n",
       "      <td>78118.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>2017-8-11</td>\n",
       "      <td>【酒厂自营】茅台醇52度500ml贵州茅台技开地之醇浓香型白酒</td>\n",
       "      <td>289.0</td>\n",
       "      <td>82</td>\n",
       "      <td>茅台醇</td>\n",
       "      <td>23698.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>2017-8-11</td>\n",
       "      <td>【酒厂自营】2013款茅台迎宾酒53度500ml</td>\n",
       "      <td>119.0</td>\n",
       "      <td>4356</td>\n",
       "      <td>迎宾</td>\n",
       "      <td>518364.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>2017-8-11</td>\n",
       "      <td>【酒厂自营】茅台王子酒53度 500ml酱门经典茅台股份酱香白酒</td>\n",
       "      <td>289.0</td>\n",
       "      <td>1645</td>\n",
       "      <td>王子酒</td>\n",
       "      <td>475405.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>2017-8-11</td>\n",
       "      <td>【酒厂自营】53度茅台王子酒500ml</td>\n",
       "      <td>189.0</td>\n",
       "      <td>3752</td>\n",
       "      <td>王子酒</td>\n",
       "      <td>709128.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>2017-8-11</td>\n",
       "      <td>【酒厂自营】贵州大曲（80年代电商专享）</td>\n",
       "      <td>299.0</td>\n",
       "      <td>1002</td>\n",
       "      <td>贵州大曲</td>\n",
       "      <td>299598.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>2017-8-11</td>\n",
       "      <td>【酒厂自营】茅台醇52度500ml贵州茅台技开天之醇浓香型白酒</td>\n",
       "      <td>399.0</td>\n",
       "      <td>13</td>\n",
       "      <td>茅台醇</td>\n",
       "      <td>5187.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>2017-8-11</td>\n",
       "      <td>【酒厂自营】茅台醇52度 500ml贵州茅台技开人之醇浓香型白酒</td>\n",
       "      <td>229.0</td>\n",
       "      <td>50</td>\n",
       "      <td>茅台醇</td>\n",
       "      <td>11450.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>2017-8-11</td>\n",
       "      <td>【酒厂自营】茅台迎宾酒43度500ml</td>\n",
       "      <td>99.0</td>\n",
       "      <td>4533</td>\n",
       "      <td>迎宾</td>\n",
       "      <td>448767.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>2017-8-11</td>\n",
       "      <td>【酒厂自营】茅台醇福醇53度500ml</td>\n",
       "      <td>589.0</td>\n",
       "      <td>175</td>\n",
       "      <td>茅台醇</td>\n",
       "      <td>103075.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>2017-8-11</td>\n",
       "      <td>【酒厂自营】汉酱酒51度125ml贵州茅台股份酱香型汉酱白酒</td>\n",
       "      <td>129.0</td>\n",
       "      <td>259</td>\n",
       "      <td>汉酱酒</td>\n",
       "      <td>33411.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>2017-8-11</td>\n",
       "      <td>【酒厂自营】仁酒53度125ml贵州茅台仁酒茅台股份酱香型白酒</td>\n",
       "      <td>119.0</td>\n",
       "      <td>209</td>\n",
       "      <td>仁酒</td>\n",
       "      <td>24871.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>2017-8-11</td>\n",
       "      <td>【酒厂自营】茅台醇美醇53度500ml</td>\n",
       "      <td>389.0</td>\n",
       "      <td>172</td>\n",
       "      <td>茅台醇</td>\n",
       "      <td>66908.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>2017-8-11</td>\n",
       "      <td>【酒厂自营】嘉宾级茅台迎宾酒 53度500ml贵州茅台迎宾酒白酒</td>\n",
       "      <td>168.0</td>\n",
       "      <td>900</td>\n",
       "      <td>迎宾</td>\n",
       "      <td>151200.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>2017-8-11</td>\n",
       "      <td>【酒厂自营】4瓶装仁酒53度125ml茅台仁酒贵州茅台酱香型白酒</td>\n",
       "      <td>388.0</td>\n",
       "      <td>67</td>\n",
       "      <td>仁酒</td>\n",
       "      <td>25996.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>2017-8-11</td>\n",
       "      <td>【酒厂自营】仁酒53度368ml茅台股份酱香型白酒</td>\n",
       "      <td>279.0</td>\n",
       "      <td>65</td>\n",
       "      <td>仁酒</td>\n",
       "      <td>18135.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>2017-8-11</td>\n",
       "      <td>赖茅酒（传承）53度500ml</td>\n",
       "      <td>399.0</td>\n",
       "      <td>331</td>\n",
       "      <td>赖茅</td>\n",
       "      <td>132069.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>2017-8-11</td>\n",
       "      <td>赖茅酒（重沙）53度500ml</td>\n",
       "      <td>299.0</td>\n",
       "      <td>294</td>\n",
       "      <td>赖茅</td>\n",
       "      <td>87906.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>2017-8-11</td>\n",
       "      <td>【酒厂自营】茅台迎宾酒（花开富贵）53度500ml</td>\n",
       "      <td>159.0</td>\n",
       "      <td>348</td>\n",
       "      <td>迎宾</td>\n",
       "      <td>55332.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>2017-8-11</td>\n",
       "      <td>【酒厂自营】茅台仁酒 53度500ml仁酒</td>\n",
       "      <td>299.0</td>\n",
       "      <td>415</td>\n",
       "      <td>仁酒</td>\n",
       "      <td>124085.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>2017-8-16</td>\n",
       "      <td>【酒厂自营】茅台醇美醇53度500ml</td>\n",
       "      <td>389.0</td>\n",
       "      <td>177</td>\n",
       "      <td>茅台醇</td>\n",
       "      <td>68853.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>2017-8-16</td>\n",
       "      <td>【酒厂自营】4瓶装仁酒53度125ml茅台仁酒贵州茅台酱香型白酒</td>\n",
       "      <td>388.0</td>\n",
       "      <td>69</td>\n",
       "      <td>仁酒</td>\n",
       "      <td>26772.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51</th>\n",
       "      <td>2017-8-16</td>\n",
       "      <td>【酒厂自营】仁酒53度368ml茅台股份酱香型白酒</td>\n",
       "      <td>279.0</td>\n",
       "      <td>65</td>\n",
       "      <td>仁酒</td>\n",
       "      <td>18135.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54</th>\n",
       "      <td>2017-8-16</td>\n",
       "      <td>【酒厂自营】仁酒53度125ml贵州茅台仁酒茅台股份酱香型白酒</td>\n",
       "      <td>119.0</td>\n",
       "      <td>212</td>\n",
       "      <td>仁酒</td>\n",
       "      <td>25228.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55</th>\n",
       "      <td>2017-8-16</td>\n",
       "      <td>【酒厂自营】茅台醇福醇53度500ml</td>\n",
       "      <td>589.0</td>\n",
       "      <td>194</td>\n",
       "      <td>茅台醇</td>\n",
       "      <td>114266.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>57</th>\n",
       "      <td>2017-8-16</td>\n",
       "      <td>【酒厂自营】茅台迎宾酒43度500ml</td>\n",
       "      <td>99.0</td>\n",
       "      <td>4582</td>\n",
       "      <td>迎宾</td>\n",
       "      <td>453618.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>78</th>\n",
       "      <td>2017-8-16</td>\n",
       "      <td>【酒厂自营】茅台迎宾酒（花开富贵）53度500ml</td>\n",
       "      <td>159.0</td>\n",
       "      <td>358</td>\n",
       "      <td>迎宾</td>\n",
       "      <td>56922.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>79</th>\n",
       "      <td>2017-8-16</td>\n",
       "      <td>赖茅酒（传承）53度500ml</td>\n",
       "      <td>399.0</td>\n",
       "      <td>334</td>\n",
       "      <td>赖茅</td>\n",
       "      <td>133266.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>81</th>\n",
       "      <td>2017-8-16</td>\n",
       "      <td>【酒厂自营】茅台汉酱酒 51度 375ml贵州茅台 汉酱酒酱香白酒</td>\n",
       "      <td>368.0</td>\n",
       "      <td>55</td>\n",
       "      <td>汉酱酒</td>\n",
       "      <td>20240.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>83</th>\n",
       "      <td>2017-8-16</td>\n",
       "      <td>【酒厂自营】汉酱酒51度125ml*4瓶装贵州茅台股份酱香型礼盒</td>\n",
       "      <td>468.0</td>\n",
       "      <td>187</td>\n",
       "      <td>汉酱酒</td>\n",
       "      <td>87516.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>85</th>\n",
       "      <td>2017-8-16</td>\n",
       "      <td>【酒厂自营】茅台仁酒 53度500ml仁酒</td>\n",
       "      <td>299.0</td>\n",
       "      <td>415</td>\n",
       "      <td>仁酒</td>\n",
       "      <td>124085.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>86</th>\n",
       "      <td>2017-8-16</td>\n",
       "      <td>【酒厂自营】茅台王子酒 46度 500ml贵州茅台王子酱香型白酒</td>\n",
       "      <td>169.0</td>\n",
       "      <td>799</td>\n",
       "      <td>王子酒</td>\n",
       "      <td>135031.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>93</th>\n",
       "      <td>2017-08-21</td>\n",
       "      <td>【酒厂自营】仁酒53度368ml茅台股份酱香型白酒</td>\n",
       "      <td>279.0</td>\n",
       "      <td>65</td>\n",
       "      <td>仁酒</td>\n",
       "      <td>18135.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95</th>\n",
       "      <td>2017-08-21</td>\n",
       "      <td>【酒厂自营】茅台王子酒53度 500ml酱门经典茅台股份酱香白酒</td>\n",
       "      <td>289.0</td>\n",
       "      <td>1669</td>\n",
       "      <td>王子酒</td>\n",
       "      <td>482341.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>96</th>\n",
       "      <td>2017-08-21</td>\n",
       "      <td>【酒厂自营】茅台仁酒 53度500ml仁酒</td>\n",
       "      <td>299.0</td>\n",
       "      <td>428</td>\n",
       "      <td>仁酒</td>\n",
       "      <td>127972.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>97</th>\n",
       "      <td>2017-08-21</td>\n",
       "      <td>【酒厂自营】茅台汉酱酒 51度 375ml贵州茅台 汉酱酒酱香白酒</td>\n",
       "      <td>368.0</td>\n",
       "      <td>57</td>\n",
       "      <td>汉酱酒</td>\n",
       "      <td>20976.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>101</th>\n",
       "      <td>2017-08-21</td>\n",
       "      <td>【酒厂自营】茅台醇福醇53度500ml</td>\n",
       "      <td>589.0</td>\n",
       "      <td>200</td>\n",
       "      <td>茅台醇</td>\n",
       "      <td>117800.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>102</th>\n",
       "      <td>2017-08-21</td>\n",
       "      <td>【酒厂自营】茅台迎宾酒43度500ml</td>\n",
       "      <td>99.0</td>\n",
       "      <td>4612</td>\n",
       "      <td>迎宾</td>\n",
       "      <td>456588.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>103</th>\n",
       "      <td>2017-08-21</td>\n",
       "      <td>【酒厂自营】嘉宾级茅台迎宾酒 53度500ml贵州茅台迎宾酒白酒</td>\n",
       "      <td>168.0</td>\n",
       "      <td>925</td>\n",
       "      <td>迎宾</td>\n",
       "      <td>155400.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>107</th>\n",
       "      <td>2017-08-21</td>\n",
       "      <td>【酒厂自营】4瓶装仁酒53度125ml茅台仁酒贵州茅台酱香型白酒</td>\n",
       "      <td>388.0</td>\n",
       "      <td>73</td>\n",
       "      <td>仁酒</td>\n",
       "      <td>28324.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>109</th>\n",
       "      <td>2017-08-21</td>\n",
       "      <td>【酒厂自营】茅台醇52度500ml贵州茅台技开地之醇浓香型白酒</td>\n",
       "      <td>289.0</td>\n",
       "      <td>85</td>\n",
       "      <td>茅台醇</td>\n",
       "      <td>24565.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>110</th>\n",
       "      <td>2017-08-21</td>\n",
       "      <td>【酒厂自营】汉酱酒51度125ml贵州茅台股份酱香型汉酱白酒</td>\n",
       "      <td>129.0</td>\n",
       "      <td>261</td>\n",
       "      <td>汉酱酒</td>\n",
       "      <td>33669.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>112</th>\n",
       "      <td>2017-08-21</td>\n",
       "      <td>赖茅酒（传承）53度500ml</td>\n",
       "      <td>399.0</td>\n",
       "      <td>372</td>\n",
       "      <td>赖茅</td>\n",
       "      <td>148428.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>114</th>\n",
       "      <td>2017-08-21</td>\n",
       "      <td>【酒厂自营】凤祥迎宾53度500ml</td>\n",
       "      <td>139.0</td>\n",
       "      <td>595</td>\n",
       "      <td>迎宾</td>\n",
       "      <td>82705.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>115</th>\n",
       "      <td>2017-08-21</td>\n",
       "      <td>【酒厂自营】仁酒53度125ml贵州茅台仁酒茅台股份酱香型白酒</td>\n",
       "      <td>119.0</td>\n",
       "      <td>213</td>\n",
       "      <td>仁酒</td>\n",
       "      <td>25347.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>119</th>\n",
       "      <td>2017-08-21</td>\n",
       "      <td>【酒厂自营】贵州大曲（80年代电商专享）</td>\n",
       "      <td>299.0</td>\n",
       "      <td>1023</td>\n",
       "      <td>贵州大曲</td>\n",
       "      <td>305877.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>120</th>\n",
       "      <td>2017-08-21</td>\n",
       "      <td>赖茅酒（端曲）53度500ml</td>\n",
       "      <td>199.0</td>\n",
       "      <td>201</td>\n",
       "      <td>赖茅</td>\n",
       "      <td>39999.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>122</th>\n",
       "      <td>2017-08-21</td>\n",
       "      <td>【酒厂自营】茅台醇52度 500ml贵州茅台技开人之醇浓香型白酒</td>\n",
       "      <td>229.0</td>\n",
       "      <td>50</td>\n",
       "      <td>茅台醇</td>\n",
       "      <td>11450.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>124</th>\n",
       "      <td>2017-08-21</td>\n",
       "      <td>【酒厂自营】茅台迎宾酒（花开富贵）53度500ml</td>\n",
       "      <td>159.0</td>\n",
       "      <td>380</td>\n",
       "      <td>迎宾</td>\n",
       "      <td>60420.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>125</th>\n",
       "      <td>2017-08-21</td>\n",
       "      <td>【酒厂自营】茅台醇顺醇53度500ml茅台技开白酒</td>\n",
       "      <td>239.0</td>\n",
       "      <td>174</td>\n",
       "      <td>茅台醇</td>\n",
       "      <td>41586.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>126</th>\n",
       "      <td>2017-08-21</td>\n",
       "      <td>【酒厂自营】2013款茅台迎宾酒53度500ml</td>\n",
       "      <td>119.0</td>\n",
       "      <td>4412</td>\n",
       "      <td>迎宾</td>\n",
       "      <td>525028.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>127</th>\n",
       "      <td>2017-08-21</td>\n",
       "      <td>【酒厂自营】汉酱酒51度125ml*4瓶装贵州茅台股份酱香型礼盒</td>\n",
       "      <td>468.0</td>\n",
       "      <td>194</td>\n",
       "      <td>汉酱酒</td>\n",
       "      <td>90792.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>129</th>\n",
       "      <td>2017-08-21</td>\n",
       "      <td>赖茅酒（重沙）53度500ml</td>\n",
       "      <td>299.0</td>\n",
       "      <td>308</td>\n",
       "      <td>赖茅</td>\n",
       "      <td>92092.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>133</th>\n",
       "      <td>2017-08-21</td>\n",
       "      <td>【酒厂自营】茅台醇美醇53度500ml</td>\n",
       "      <td>389.0</td>\n",
       "      <td>184</td>\n",
       "      <td>茅台醇</td>\n",
       "      <td>71576.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>134</th>\n",
       "      <td>2017-08-21</td>\n",
       "      <td>【酒厂自营】茅台醇52度500ml贵州茅台技开天之醇浓香型白酒</td>\n",
       "      <td>399.0</td>\n",
       "      <td>13</td>\n",
       "      <td>茅台醇</td>\n",
       "      <td>5187.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>137</th>\n",
       "      <td>2017-08-21</td>\n",
       "      <td>【酒厂自营】茅台王子酒 46度 500ml贵州茅台王子酱香型白酒</td>\n",
       "      <td>169.0</td>\n",
       "      <td>802</td>\n",
       "      <td>王子酒</td>\n",
       "      <td>135538.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>72 rows × 6 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "             时间                                商品名     价格    销量    品牌  \\\n",
       "0     2017-8-11   【酒厂自营】茅台王子酒 46度 500ml贵州茅台王子酱香型白酒  169.0   799   王子酒   \n",
       "2     2017-8-11  【酒厂自营】茅台汉酱酒 51度 375ml贵州茅台 汉酱酒酱香白酒  368.0    47   汉酱酒   \n",
       "4     2017-8-11                    赖茅酒（端曲）53度500ml  199.0   186    赖茅   \n",
       "8     2017-8-11   【酒厂自营】汉酱酒51度125ml*4瓶装贵州茅台股份酱香型礼盒  468.0   182   汉酱酒   \n",
       "9     2017-8-11                 【酒厂自营】凤祥迎宾53度500ml  139.0   562    迎宾   \n",
       "10    2017-8-11    【酒厂自营】茅台醇52度500ml贵州茅台技开地之醇浓香型白酒  289.0    82   茅台醇   \n",
       "11    2017-8-11           【酒厂自营】2013款茅台迎宾酒53度500ml  119.0  4356    迎宾   \n",
       "12    2017-8-11   【酒厂自营】茅台王子酒53度 500ml酱门经典茅台股份酱香白酒  289.0  1645   王子酒   \n",
       "13    2017-8-11                【酒厂自营】53度茅台王子酒500ml  189.0  3752   王子酒   \n",
       "17    2017-8-11               【酒厂自营】贵州大曲（80年代电商专享）  299.0  1002  贵州大曲   \n",
       "19    2017-8-11    【酒厂自营】茅台醇52度500ml贵州茅台技开天之醇浓香型白酒  399.0    13   茅台醇   \n",
       "21    2017-8-11   【酒厂自营】茅台醇52度 500ml贵州茅台技开人之醇浓香型白酒  229.0    50   茅台醇   \n",
       "22    2017-8-11                【酒厂自营】茅台迎宾酒43度500ml   99.0  4533    迎宾   \n",
       "25    2017-8-11                【酒厂自营】茅台醇福醇53度500ml  589.0   175   茅台醇   \n",
       "27    2017-8-11     【酒厂自营】汉酱酒51度125ml贵州茅台股份酱香型汉酱白酒  129.0   259   汉酱酒   \n",
       "28    2017-8-11    【酒厂自营】仁酒53度125ml贵州茅台仁酒茅台股份酱香型白酒  119.0   209    仁酒   \n",
       "29    2017-8-11                【酒厂自营】茅台醇美醇53度500ml  389.0   172   茅台醇   \n",
       "33    2017-8-11   【酒厂自营】嘉宾级茅台迎宾酒 53度500ml贵州茅台迎宾酒白酒  168.0   900    迎宾   \n",
       "36    2017-8-11   【酒厂自营】4瓶装仁酒53度125ml茅台仁酒贵州茅台酱香型白酒  388.0    67    仁酒   \n",
       "37    2017-8-11          【酒厂自营】仁酒53度368ml茅台股份酱香型白酒  279.0    65    仁酒   \n",
       "40    2017-8-11                    赖茅酒（传承）53度500ml  399.0   331    赖茅   \n",
       "41    2017-8-11                    赖茅酒（重沙）53度500ml  299.0   294    赖茅   \n",
       "42    2017-8-11          【酒厂自营】茅台迎宾酒（花开富贵）53度500ml  159.0   348    迎宾   \n",
       "44    2017-8-11              【酒厂自营】茅台仁酒 53度500ml仁酒  299.0   415    仁酒   \n",
       "48    2017-8-16                【酒厂自营】茅台醇美醇53度500ml  389.0   177   茅台醇   \n",
       "49    2017-8-16   【酒厂自营】4瓶装仁酒53度125ml茅台仁酒贵州茅台酱香型白酒  388.0    69    仁酒   \n",
       "51    2017-8-16          【酒厂自营】仁酒53度368ml茅台股份酱香型白酒  279.0    65    仁酒   \n",
       "54    2017-8-16    【酒厂自营】仁酒53度125ml贵州茅台仁酒茅台股份酱香型白酒  119.0   212    仁酒   \n",
       "55    2017-8-16                【酒厂自营】茅台醇福醇53度500ml  589.0   194   茅台醇   \n",
       "57    2017-8-16                【酒厂自营】茅台迎宾酒43度500ml   99.0  4582    迎宾   \n",
       "..          ...                                ...    ...   ...   ...   \n",
       "78    2017-8-16          【酒厂自营】茅台迎宾酒（花开富贵）53度500ml  159.0   358    迎宾   \n",
       "79    2017-8-16                    赖茅酒（传承）53度500ml  399.0   334    赖茅   \n",
       "81    2017-8-16  【酒厂自营】茅台汉酱酒 51度 375ml贵州茅台 汉酱酒酱香白酒  368.0    55   汉酱酒   \n",
       "83    2017-8-16   【酒厂自营】汉酱酒51度125ml*4瓶装贵州茅台股份酱香型礼盒  468.0   187   汉酱酒   \n",
       "85    2017-8-16              【酒厂自营】茅台仁酒 53度500ml仁酒  299.0   415    仁酒   \n",
       "86    2017-8-16   【酒厂自营】茅台王子酒 46度 500ml贵州茅台王子酱香型白酒  169.0   799   王子酒   \n",
       "93   2017-08-21          【酒厂自营】仁酒53度368ml茅台股份酱香型白酒  279.0    65    仁酒   \n",
       "95   2017-08-21   【酒厂自营】茅台王子酒53度 500ml酱门经典茅台股份酱香白酒  289.0  1669   王子酒   \n",
       "96   2017-08-21              【酒厂自营】茅台仁酒 53度500ml仁酒  299.0   428    仁酒   \n",
       "97   2017-08-21  【酒厂自营】茅台汉酱酒 51度 375ml贵州茅台 汉酱酒酱香白酒  368.0    57   汉酱酒   \n",
       "101  2017-08-21                【酒厂自营】茅台醇福醇53度500ml  589.0   200   茅台醇   \n",
       "102  2017-08-21                【酒厂自营】茅台迎宾酒43度500ml   99.0  4612    迎宾   \n",
       "103  2017-08-21   【酒厂自营】嘉宾级茅台迎宾酒 53度500ml贵州茅台迎宾酒白酒  168.0   925    迎宾   \n",
       "107  2017-08-21   【酒厂自营】4瓶装仁酒53度125ml茅台仁酒贵州茅台酱香型白酒  388.0    73    仁酒   \n",
       "109  2017-08-21    【酒厂自营】茅台醇52度500ml贵州茅台技开地之醇浓香型白酒  289.0    85   茅台醇   \n",
       "110  2017-08-21     【酒厂自营】汉酱酒51度125ml贵州茅台股份酱香型汉酱白酒  129.0   261   汉酱酒   \n",
       "112  2017-08-21                    赖茅酒（传承）53度500ml  399.0   372    赖茅   \n",
       "114  2017-08-21                 【酒厂自营】凤祥迎宾53度500ml  139.0   595    迎宾   \n",
       "115  2017-08-21    【酒厂自营】仁酒53度125ml贵州茅台仁酒茅台股份酱香型白酒  119.0   213    仁酒   \n",
       "119  2017-08-21               【酒厂自营】贵州大曲（80年代电商专享）  299.0  1023  贵州大曲   \n",
       "120  2017-08-21                    赖茅酒（端曲）53度500ml  199.0   201    赖茅   \n",
       "122  2017-08-21   【酒厂自营】茅台醇52度 500ml贵州茅台技开人之醇浓香型白酒  229.0    50   茅台醇   \n",
       "124  2017-08-21          【酒厂自营】茅台迎宾酒（花开富贵）53度500ml  159.0   380    迎宾   \n",
       "125  2017-08-21          【酒厂自营】茅台醇顺醇53度500ml茅台技开白酒  239.0   174   茅台醇   \n",
       "126  2017-08-21           【酒厂自营】2013款茅台迎宾酒53度500ml  119.0  4412    迎宾   \n",
       "127  2017-08-21   【酒厂自营】汉酱酒51度125ml*4瓶装贵州茅台股份酱香型礼盒  468.0   194   汉酱酒   \n",
       "129  2017-08-21                    赖茅酒（重沙）53度500ml  299.0   308    赖茅   \n",
       "133  2017-08-21                【酒厂自营】茅台醇美醇53度500ml  389.0   184   茅台醇   \n",
       "134  2017-08-21    【酒厂自营】茅台醇52度500ml贵州茅台技开天之醇浓香型白酒  399.0    13   茅台醇   \n",
       "137  2017-08-21   【酒厂自营】茅台王子酒 46度 500ml贵州茅台王子酱香型白酒  169.0   802   王子酒   \n",
       "\n",
       "          销售额  \n",
       "0    135031.0  \n",
       "2     17296.0  \n",
       "4     37014.0  \n",
       "8     85176.0  \n",
       "9     78118.0  \n",
       "10    23698.0  \n",
       "11   518364.0  \n",
       "12   475405.0  \n",
       "13   709128.0  \n",
       "17   299598.0  \n",
       "19     5187.0  \n",
       "21    11450.0  \n",
       "22   448767.0  \n",
       "25   103075.0  \n",
       "27    33411.0  \n",
       "28    24871.0  \n",
       "29    66908.0  \n",
       "33   151200.0  \n",
       "36    25996.0  \n",
       "37    18135.0  \n",
       "40   132069.0  \n",
       "41    87906.0  \n",
       "42    55332.0  \n",
       "44   124085.0  \n",
       "48    68853.0  \n",
       "49    26772.0  \n",
       "51    18135.0  \n",
       "54    25228.0  \n",
       "55   114266.0  \n",
       "57   453618.0  \n",
       "..        ...  \n",
       "78    56922.0  \n",
       "79   133266.0  \n",
       "81    20240.0  \n",
       "83    87516.0  \n",
       "85   124085.0  \n",
       "86   135031.0  \n",
       "93    18135.0  \n",
       "95   482341.0  \n",
       "96   127972.0  \n",
       "97    20976.0  \n",
       "101  117800.0  \n",
       "102  456588.0  \n",
       "103  155400.0  \n",
       "107   28324.0  \n",
       "109   24565.0  \n",
       "110   33669.0  \n",
       "112  148428.0  \n",
       "114   82705.0  \n",
       "115   25347.0  \n",
       "119  305877.0  \n",
       "120   39999.0  \n",
       "122   11450.0  \n",
       "124   60420.0  \n",
       "125   41586.0  \n",
       "126  525028.0  \n",
       "127   90792.0  \n",
       "129   92092.0  \n",
       "133   71576.0  \n",
       "134    5187.0  \n",
       "137  135538.0  \n",
       "\n",
       "[72 rows x 6 columns]"
      ]
     },
     "execution_count": 39,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "mtmall"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "maotai_0811 = mtmall[mtmall['时间'] == '2017-8-11']\n",
    "maotai_0816 = mtmall[mtmall['时间'] == '2017-8-16']\n",
    "maotai_0821 = mtmall[mtmall['时间'] == '2017-08-21']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>价格</th>\n",
       "      <th>销量</th>\n",
       "      <th>销售额</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>count</th>\n",
       "      <td>24.000000</td>\n",
       "      <td>24.000000</td>\n",
       "      <td>24.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>mean</th>\n",
       "      <td>269.666667</td>\n",
       "      <td>851.833333</td>\n",
       "      <td>152800.833333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>std</th>\n",
       "      <td>127.407824</td>\n",
       "      <td>1357.876464</td>\n",
       "      <td>191865.014377</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>min</th>\n",
       "      <td>99.000000</td>\n",
       "      <td>13.000000</td>\n",
       "      <td>5187.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25%</th>\n",
       "      <td>165.750000</td>\n",
       "      <td>149.500000</td>\n",
       "      <td>25714.750000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50%</th>\n",
       "      <td>284.000000</td>\n",
       "      <td>276.500000</td>\n",
       "      <td>81647.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75%</th>\n",
       "      <td>373.000000</td>\n",
       "      <td>824.250000</td>\n",
       "      <td>139073.250000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>max</th>\n",
       "      <td>589.000000</td>\n",
       "      <td>4533.000000</td>\n",
       "      <td>709128.000000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "               价格           销量            销售额\n",
       "count   24.000000    24.000000      24.000000\n",
       "mean   269.666667   851.833333  152800.833333\n",
       "std    127.407824  1357.876464  191865.014377\n",
       "min     99.000000    13.000000    5187.000000\n",
       "25%    165.750000   149.500000   25714.750000\n",
       "50%    284.000000   276.500000   81647.000000\n",
       "75%    373.000000   824.250000  139073.250000\n",
       "max    589.000000  4533.000000  709128.000000"
      ]
     },
     "execution_count": 40,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "maotai_0811.describe()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 41,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>价格</th>\n",
       "      <th>销量</th>\n",
       "      <th>销售额</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>count</th>\n",
       "      <td>24.000000</td>\n",
       "      <td>24.000000</td>\n",
       "      <td>24.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>mean</th>\n",
       "      <td>269.666667</td>\n",
       "      <td>861.708333</td>\n",
       "      <td>155012.500000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>std</th>\n",
       "      <td>127.407824</td>\n",
       "      <td>1370.634143</td>\n",
       "      <td>193717.799738</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>min</th>\n",
       "      <td>99.000000</td>\n",
       "      <td>13.000000</td>\n",
       "      <td>5187.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25%</th>\n",
       "      <td>165.750000</td>\n",
       "      <td>153.750000</td>\n",
       "      <td>26386.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50%</th>\n",
       "      <td>284.000000</td>\n",
       "      <td>280.500000</td>\n",
       "      <td>83442.500000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75%</th>\n",
       "      <td>373.000000</td>\n",
       "      <td>826.250000</td>\n",
       "      <td>139409.250000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>max</th>\n",
       "      <td>589.000000</td>\n",
       "      <td>4582.000000</td>\n",
       "      <td>722358.000000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "               价格           销量            销售额\n",
       "count   24.000000    24.000000      24.000000\n",
       "mean   269.666667   861.708333  155012.500000\n",
       "std    127.407824  1370.634143  193717.799738\n",
       "min     99.000000    13.000000    5187.000000\n",
       "25%    165.750000   153.750000   26386.000000\n",
       "50%    284.000000   280.500000   83442.500000\n",
       "75%    373.000000   826.250000  139409.250000\n",
       "max    589.000000  4582.000000  722358.000000"
      ]
     },
     "execution_count": 41,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "maotai_0816.describe()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>价格</th>\n",
       "      <th>销量</th>\n",
       "      <th>销售额</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>count</th>\n",
       "      <td>24.000000</td>\n",
       "      <td>24.000000</td>\n",
       "      <td>24.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>mean</th>\n",
       "      <td>271.750000</td>\n",
       "      <td>720.666667</td>\n",
       "      <td>129241.458333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>std</th>\n",
       "      <td>126.436528</td>\n",
       "      <td>1230.690321</td>\n",
       "      <td>153798.318087</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>min</th>\n",
       "      <td>99.000000</td>\n",
       "      <td>13.000000</td>\n",
       "      <td>5187.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25%</th>\n",
       "      <td>165.750000</td>\n",
       "      <td>151.750000</td>\n",
       "      <td>27579.750000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50%</th>\n",
       "      <td>284.000000</td>\n",
       "      <td>237.000000</td>\n",
       "      <td>77140.500000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75%</th>\n",
       "      <td>373.000000</td>\n",
       "      <td>646.750000</td>\n",
       "      <td>138760.500000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>max</th>\n",
       "      <td>589.000000</td>\n",
       "      <td>4612.000000</td>\n",
       "      <td>525028.000000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "               价格           销量            销售额\n",
       "count   24.000000    24.000000      24.000000\n",
       "mean   271.750000   720.666667  129241.458333\n",
       "std    126.436528  1230.690321  153798.318087\n",
       "min     99.000000    13.000000    5187.000000\n",
       "25%    165.750000   151.750000   27579.750000\n",
       "50%    284.000000   237.000000   77140.500000\n",
       "75%    373.000000   646.750000  138760.500000\n",
       "max    589.000000  4612.000000  525028.000000"
      ]
     },
     "execution_count": 37,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "maotai_0821.describe()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "hide_input": false,
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.0"
  },
  "toc": {
   "colors": {
    "hover_highlight": "#DAA520",
    "navigate_num": "#000000",
    "navigate_text": "#333333",
    "running_highlight": "#FF0000",
    "selected_highlight": "#FFD700",
    "sidebar_border": "#EEEEEE",
    "wrapper_background": "#FFFFFF"
   },
   "moveMenuLeft": true,
   "nav_menu": {
    "height": "12px",
    "width": "252px"
   },
   "navigate_menu": true,
   "number_sections": true,
   "sideBar": true,
   "threshold": 4,
   "toc_cell": false,
   "toc_section_display": "block",
   "toc_window_display": false,
   "widenNotebook": false
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}
